﻿using Magicodes.ExporterAndImporter.Core;
using Magicodes.ExporterAndImporter.Excel;
using OfficeOpenXml.Table;
using System;
using System.Collections.Generic;
using System.Text;

namespace NP.BPMReportPlatform.AUTO.Adjust.Dto
{
    [ExcelExporter(Name = "AUTO新KG调价流程报表数据", TableStyle = TableStyles.Light10, AutoFitAllColumn = true)]
    public class ExportKGAdjustOutput
    {
        /// <summary>
        /// 序号
        /// </summary>
        [ExporterHeader(DisplayName = "序号")]
        public string SerialNumber { get; set; }

        /// <summary>
        /// 流程编号
        /// </summary>
        [ExporterHeader(DisplayName = "流程编号")]
        public string InstanceNumber { get; set; }

        /// <summary>
        /// 流程创建时间
        /// </summary>
        [ExporterHeader(DisplayName = "流程创建时间")]
        public string CreateTime { get; set; }

        /// <summary>
        /// 单据状态
        /// </summary>        
        [ExporterHeader(DisplayName = "单据状态")]
        public string OrderStatus { get; set; }

        /// <summary>
        /// 销售组织(开盘公司)
        /// </summary>
        [ExporterHeader(DisplayName = "销售组织")]
        public string SaleRegion { get; set; }

        /// <summary>
        /// 事业部
        /// </summary>
        [ExporterHeader(DisplayName = "事业部")]
        public string AppoverType { get; set; }
        /// <summary>
        /// 行业
        /// </summary>
        [ExporterHeader(DisplayName = "行业")]
        public string AutoType { get; set; }
        /// <summary>
        /// 细分市场
        /// </summary>
        [ExporterHeader(DisplayName = "细分市场")]
        public string AutoType2 { get; set; }

        /// <summary>
        /// 客户类型
        /// </summary>
        [ExporterHeader(DisplayName = "客户类型")]
        public string CustomerStatus { get; set; }

        /// <summary>
        /// 商机号
        /// </summary>
        [ExporterHeader(DisplayName = "商机号")]
        public string BusinessOpportunities { get; set; }

        /// <summary>
        /// 客户编码
        /// </summary>
        [ExporterHeader(DisplayName = "客户编码")]
        public string CustomerNo { get; set; }

        /// <summary>
        /// 客户名称
        /// </summary>
        [ExporterHeader(DisplayName = "客户名称")]
        public string CustomerName { get; set; }

        /// <summary>
        /// 客户分级
        /// </summary>
        [ExporterHeader(DisplayName = "客户分级")]
        public string CustomerRank { get; set; }

        /// <summary>
        /// 企业性质
        /// </summary>
        [ExporterHeader(DisplayName = "企业性质")]
        public string CompanyType { get; set; }

        /// <summary>
        /// 客户类别
        /// </summary>
        [ExporterHeader(DisplayName = "客户类别")]
        public string CustomerCatalog { get; set; }

        /// <summary>
        /// 送货方式
        /// </summary>
        [ExporterHeader(DisplayName = "送货方式")]
        public string DeliverType { get; set; }

        /// <summary>
        /// 结算方式
        /// </summary>
        [ExporterHeader(DisplayName = "结算方式")]
        public string BalanceType { get; set; }

        /// <summary>
        /// 价格有效截止日期
        /// </summary>
        [ExporterHeader(DisplayName = "价格有效截止日期")]
        public string PriceEndtime { get; set; }

        /// <summary>
        /// 产品编码
        /// </summary>
        [ExporterHeader(DisplayName = "产品编码")]
        public string ProductCode { get; set; }

        /// <summary>
        /// 产品名称
        /// </summary>
        [ExporterHeader(DisplayName = "产品名称")]
        public string ProductName { get; set; }

        /// <summary>
        /// PDT
        /// </summary>
        [ExporterHeader(DisplayName = "PDT")]
        public string PDT { get; set; }

        /// <summary>
        /// PDT组织
        /// </summary>
        [ExporterHeader(DisplayName = "PDT组织")]
        public string PDTDesc { get; set; }

        /// <summary>
        /// 出货工厂
        /// </summary>
        [ExporterHeader(DisplayName = "出货工厂")]
        public string SaleRegion1 { get; set; }

        /// <summary>
        /// 产品属性
        /// </summary>
        [ExporterHeader(DisplayName = "产品属性")]
        public string ProductType { get; set; }

        /// <summary>
        /// 销售单位
        /// </summary>
        [ExporterHeader(DisplayName = "销售单位")]
        public string SalesUnit { get; set; }

        /// <summary>
        /// 单位转化KG
        /// </summary>
        [ExporterHeader(DisplayName = "单位转化KG")]
        public string ConversionKG { get; set; }

        /// <summary>
        /// 现价含税 (RMB/单位）
        /// </summary>
        [ExporterHeader(DisplayName = "现价含税 (RMB/单位）")]
        public string CurrentPrice { get; set; }

        /// <summary>
        /// 现价不含税 (RMB/KG)
        /// </summary>
        [ExporterHeader(DisplayName = "现价不含税 (RMB/KG)")]
        public string CurrentPriceNoTax { get; set; }

        /// <summary>
        /// 拟调价至含税 (RMB/单位）
        /// </summary>
        [ExporterHeader(DisplayName = "拟调价至含税 (RMB/单位）")]
        public string AdjustPrice { get; set; }

        /// <summary>
        /// 拟调价至不含税 (RMB/KG)
        /// </summary>
        [ExporterHeader(DisplayName = "拟调价至不含税 (RMB/KG)")]
        public string AdjustPriceNoTax { get; set; }

        /// <summary>
        /// 调整幅度（%）
        /// </summary>
        [ExporterHeader(DisplayName = "调整幅度（%）")]
        public string AdjustPriceRange { get; set; }

        /// <summary>
        /// 月度用量预计
        /// </summary>
        [ExporterHeader(DisplayName = "月度用量预计")]
        public string FixedMonthlyAmount { get; set; }

        /// <summary>
        /// 生产加工费（元/KG）
        /// </summary>
        [ExporterHeader(DisplayName = "生产加工费")]
        public string ProcessingFee { get; set; }

        /// <summary>
        /// 生产加工费%（元/KG）
        /// </summary>
        [ExporterHeader(DisplayName = "生产加工费比例%")]
        public string ProcessingFeeRatio { get; set; }
   
        /// <summary>
        /// RMC(移动平均价)
        /// </summary>
        [ExporterHeader(DisplayName = "RMC(移动平均价)")]
        public string RMC { get; set; }

        /// <summary>
        /// RMC2(最新采购价）
        /// </summary>
        [ExporterHeader(DisplayName = "RMC2(最新采购价）")]
        public string RMC2 { get; set; }

        /// <summary>
        /// 调价前RMC%(移动平均价)
        /// </summary>
        [ExporterHeader(DisplayName = "调价前RMC%(移动平均价)")]
        public string RMCRatio { get; set; }

        /// <summary>
        /// 调价前RMC2%（最新采购价）
        /// </summary>
        [ExporterHeader(DisplayName = "调价前RMC2%（最新采购价）")]
        public string RMC2Ratio { get; set; }

        /// <summary>
        /// 调价后RMC%(移动平均价)
        /// </summary>
        [ExporterHeader(DisplayName = "调价后RMC%(移动平均价)")]
        public string RMCRatioAfter { get; set; }

        /// <summary>
        /// 调价后RMC2%（最新采购价）
        /// </summary>
        [ExporterHeader(DisplayName = "调价后RMC2%（最新采购价）")]
        public string RMC2RatioAfter { get; set; }

        /// <summary>
        /// RMC2报错提示
        /// </summary>
        [ExporterHeader(DisplayName = "RMC2报错提示")]
        public string RMC2ErroPrompt { get; set; }

        /// <summary>
        /// 扣减加工费后毛利（移动平均价）
        /// </summary>
        [ExporterHeader(DisplayName = "扣减加工费后毛利（移动平均价）")]
        public string GrossProfit1 { get; set; }

        /// <summary>
        /// 扣减加工费后毛利2(最新采购价)
        /// </summary>
        [ExporterHeader(DisplayName = "扣减加工费后毛利(最新采购价)")]
        public string GrossProfit2 { get; set; }

        /// <summary>
        /// 理论价格
        /// </summary>
        [ExporterHeader(DisplayName = "理论价格")]
        public string TheoreticalPrice { get; set; }

        /// <summary>
        ///  是否满足公司报价要求
        /// </summary>
        [ExporterHeader(DisplayName = "是否满足公司报价要求")]
        public string PriceEstimation1 { get; set; }

        /// <summary>
        /// 是否满足行业毛利要求
        /// </summary>
        [ExporterHeader(DisplayName = "是否满足行业毛利要求")]
        public string PriceEstimation2 { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [ExporterHeader(DisplayName = "备注")]
        public string Remark { get; set; }

        /// <summary>
        /// 审批
        /// </summary>
        [ExporterHeader(DisplayName = "审批")]
        public string SyncSAP { get; set; }

        /// <summary>
        /// 审批完成时间
        /// </summary>
        [ExporterHeader(DisplayName = "审批完成时间")]
        public string ApproveDate { get; set; }
    }
}
